object DepoDurumuF: TDepoDurumuF
  Left = 152
  Top = 171
  BorderIcons = [biSystemMenu]
  BorderStyle = bsSingle
  Caption = 'Depo Durumu'
  ClientHeight = 454
  ClientWidth = 948
  Color = clBtnFace
  Font.Charset = TURKISH_CHARSET
  Font.Color = clWindowText
  Font.Height = -11
  Font.Name = 'Arial'
  Font.Style = []
  KeyPreview = True
  OldCreateOrder = False
  Position = poDefaultPosOnly
  OnClose = FormClose
  OnKeyPress = FormKeyPress
  OnShow = FormShow
  PixelsPerInch = 96
  TextHeight = 14
  object cxgrid1: TcxGrid
    Left = 0
    Top = 85
    Width = 948
    Height = 336
    Align = alClient
    TabOrder = 0
    LookAndFeel.NativeStyle = True
    object cxgrid1DBTableView1: TcxGridDBTableView
      NavigatorButtons.ConfirmDelete = False
      DataController.DataSource = FaturaQS
      DataController.Filter.Active = True
      DataController.Filter.AutoDataSetFilter = True
      DataController.Options = [dcoAnsiSort, dcoAssignGroupingValues, dcoAssignMasterDetailKeys, dcoSaveExpanding]
      DataController.Summary.DefaultGroupSummaryItems = <
        item
          Format = 'Adet : ###.###'
          Kind = skCount
          FieldName = 'bilisno'
          Column = cxgrid1DBTableView1bilisno
        end>
      DataController.Summary.FooterSummaryItems = <>
      DataController.Summary.SummaryGroups = <>
      OptionsBehavior.IncSearch = True
      OptionsData.CancelOnExit = False
      OptionsData.Deleting = False
      OptionsData.DeletingConfirmation = False
      OptionsData.Editing = False
      OptionsData.Inserting = False
      OptionsSelection.CellSelect = False
      OptionsSelection.UnselectFocusedRecordOnExit = False
      OptionsView.ColumnAutoWidth = True
      OptionsView.Indicator = True
      Styles.StyleSheet = dm.tvssDevExpress
      object cxgrid1DBTableView1iptal: TcxGridDBColumn
        DataBinding.FieldName = 'iptal'
        Options.Filtering = False
        Width = 20
        IsCaptionAssigned = True
      end
      object cxgrid1DBTableView1tarih: TcxGridDBColumn
        Caption = 'Tarih'
        DataBinding.FieldName = 'tarih'
        Width = 100
      end
      object cxgrid1DBTableView1faturatipi: TcxGridDBColumn
        Caption = #304'rsaliye Tipi'
        DataBinding.FieldName = 'faturatipi'
        PropertiesClassName = 'TcxImageComboBoxProperties'
        Properties.Alignment.Horz = taLeftJustify
        Properties.Items = <
          item
            Description = 'Mal Al'#305'm '#304'rsaliyesi'
            Value = '1'
          end
          item
            Description = 'Al'#305'm '#304'ade '#304'rsaliyesi'
            Value = '6'
          end
          item
            Description = 'Toptan Sat'#305#351' '#304'rsaliyesi'
            Value = '8'
          end
          item
            Description = 'Sat'#305#351' '#304'ade '#304'rsaliyesi'
            Value = '3'
          end
          item
            Description = 'Giri'#351' Belgesi'
            Value = '90'
          end
          item
            Description = #199#305'k'#305#351' Belgesi'
            Value = '80'
          end
          item
            Description = 'Konsinye Giri'#351' '#304'rsaliyesi'
            Value = '5'
          end
          item
            Description = 'Konsinye '#199#305'k'#305#351' '#304'rsaliyesi'
            Value = '9'
          end>
        SortIndex = 0
        SortOrder = soAscending
        Width = 120
      end
      object cxgrid1DBTableView1bilisno: TcxGridDBColumn
        Caption = 'Bil.'#304#351'. No'
        DataBinding.FieldName = 'bilisno'
        Width = 60
      end
      object cxgrid1DBTableView1belgeno: TcxGridDBColumn
        Caption = 'Sipari'#351' No'
        DataBinding.FieldName = 'belgeno'
        Width = 70
      end
      object cxgrid1DBTableView1unityfaturano: TcxGridDBColumn
        Caption = 'Fatura No'
        DataBinding.FieldName = 'unityfaturano'
        Width = 70
      end
      object cxgrid1DBTableView1firmaadi: TcxGridDBColumn
        Caption = 'Firma Ad'#305
        DataBinding.FieldName = 'firmaadi'
        Width = 220
      end
      object cxgrid1DBTableView1ambar: TcxGridDBColumn
        Caption = 'Ambar Ad'#305
        DataBinding.FieldName = 'ambaradi'
        Width = 75
      end
      object cxgrid1DBTableView1bolumkodu: TcxGridDBColumn
        Caption = 'B'#246'l'#252'm Ad'#305
        DataBinding.FieldName = 'bolumkodu'
        PropertiesClassName = 'TcxImageComboBoxProperties'
        Properties.Items = <
          item
            Description = #220'retim'
            Value = 'U'
          end
          item
            Description = 'Merkez'
            Value = 'M'
          end
          item
            Description = 'Ma'#287'aza'
            Value = 'Z'
          end>
        Width = 75
      end
      object cxgrid1DBTableView1durum: TcxGridDBColumn
        Caption = 'Stat'#252's'#252
        DataBinding.FieldName = 'durum'
        PropertiesClassName = 'TcxImageComboBoxProperties'
        Properties.Alignment.Horz = taLeftJustify
        Properties.Items = <
          item
            Description = #304#351'lem Yap'#305'lmad'#305
            Value = '1'
          end
          item
            Description = 'Devam Ediyor'
            Value = '2'
          end
          item
            Description = 'Tamamland'#305
            Value = '3'
          end
          item
            Description = 'G'#246'nderildi'
            Value = '4'
          end>
        Width = 100
      end
    end
    object cxgrid1Level1: TcxGridLevel
      GridView = cxgrid1DBTableView1
    end
  end
  object Panel1: TPanel
    Left = 0
    Top = 0
    Width = 948
    Height = 85
    Align = alTop
    BevelOuter = bvNone
    TabOrder = 1
    object Label1: TLabel
      Left = 8
      Top = 34
      Width = 172
      Height = 14
      Caption = 'Tamamland'#305' Olmayan Sipari'#351'ler'
      Font.Charset = TURKISH_CHARSET
      Font.Color = clBlack
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = [fsBold]
      ParentFont = False
      Transparent = True
    end
    object Label3: TLabel
      Left = 188
      Top = 6
      Width = 45
      Height = 14
      AutoSize = False
      Caption = 'Merkez'
      Transparent = True
    end
    object Label2: TLabel
      Left = 233
      Top = 6
      Width = 45
      Height = 14
      AutoSize = False
      Caption = 'Ma'#287'aza'
      Transparent = True
    end
    object Label4: TLabel
      Left = 281
      Top = 6
      Width = 35
      Height = 14
      AutoSize = False
      Caption = #220'retim'
      Transparent = True
    end
    object Label5: TLabel
      Left = 321
      Top = 6
      Width = 35
      Height = 14
      AutoSize = False
      Caption = 'Toplam'
      Transparent = True
    end
    object Label6: TLabel
      Left = 8
      Top = 58
      Width = 133
      Height = 14
      Caption = 'Okutulmayan '#220'r'#252'n Adeti'
      Font.Charset = TURKISH_CHARSET
      Font.Color = clBlack
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = [fsBold]
      ParentFont = False
      Transparent = True
    end
    object t1: TStaticText
      Left = 195
      Top = 32
      Width = 26
      Height = 18
      Alignment = taCenter
      AutoSize = False
      BorderStyle = sbsSunken
      Caption = '0'
      Font.Charset = TURKISH_CHARSET
      Font.Color = clRed
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = [fsBold]
      ParentFont = False
      TabOrder = 0
      Transparent = False
    end
    object t2: TStaticText
      Left = 239
      Top = 32
      Width = 26
      Height = 18
      Alignment = taCenter
      AutoSize = False
      BorderStyle = sbsSunken
      Caption = '0'
      Font.Charset = TURKISH_CHARSET
      Font.Color = clNavy
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = [fsBold]
      ParentFont = False
      TabOrder = 1
      Transparent = False
    end
    object t3: TStaticText
      Left = 282
      Top = 32
      Width = 26
      Height = 18
      Alignment = taCenter
      AutoSize = False
      BorderStyle = sbsSunken
      Caption = '0'
      Font.Charset = TURKISH_CHARSET
      Font.Color = clRed
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = [fsBold]
      ParentFont = False
      TabOrder = 2
      Transparent = False
    end
    object t4: TStaticText
      Left = 322
      Top = 32
      Width = 26
      Height = 18
      Alignment = taCenter
      AutoSize = False
      BorderStyle = sbsSunken
      Caption = '0'
      Font.Charset = TURKISH_CHARSET
      Font.Color = clNavy
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = [fsBold]
      ParentFont = False
      TabOrder = 3
      Transparent = False
    end
    object o1: TStaticText
      Left = 195
      Top = 56
      Width = 26
      Height = 18
      Alignment = taCenter
      AutoSize = False
      BorderStyle = sbsSunken
      Caption = '0'
      Font.Charset = TURKISH_CHARSET
      Font.Color = clRed
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = [fsBold]
      ParentFont = False
      TabOrder = 4
      Transparent = False
    end
    object o2: TStaticText
      Left = 239
      Top = 56
      Width = 26
      Height = 18
      Alignment = taCenter
      AutoSize = False
      BorderStyle = sbsSunken
      Caption = '0'
      Font.Charset = TURKISH_CHARSET
      Font.Color = clNavy
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = [fsBold]
      ParentFont = False
      TabOrder = 5
      Transparent = False
    end
    object o3: TStaticText
      Left = 282
      Top = 56
      Width = 26
      Height = 18
      Alignment = taCenter
      AutoSize = False
      BorderStyle = sbsSunken
      Caption = '0'
      Font.Charset = TURKISH_CHARSET
      Font.Color = clRed
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = [fsBold]
      ParentFont = False
      TabOrder = 6
      Transparent = False
    end
    object o4: TStaticText
      Left = 322
      Top = 56
      Width = 26
      Height = 18
      Alignment = taCenter
      AutoSize = False
      BorderStyle = sbsSunken
      Caption = '0'
      Font.Charset = TURKISH_CHARSET
      Font.Color = clNavy
      Font.Height = -11
      Font.Name = 'Arial'
      Font.Style = [fsBold]
      ParentFont = False
      TabOrder = 7
      Transparent = False
    end
  end
  object Panel2: TPanel
    Left = 0
    Top = 421
    Width = 948
    Height = 33
    Align = alBottom
    BevelOuter = bvNone
    TabOrder = 2
    DesignSize = (
      948
      33)
    object bkapat: TBitBtn
      Left = 869
      Top = 5
      Width = 75
      Height = 25
      Anchors = [akRight, akBottom]
      Caption = 'Kapat'
      TabOrder = 0
      OnClick = bkapatClick
    end
    object bincele: TBitBtn
      Left = 3
      Top = 5
      Width = 84
      Height = 25
      Caption = '&'#304'ncele'
      TabOrder = 1
      OnClick = binceleClick
    end
  end
  object TamamlandiOlmayanQ: TADOQuery
    Connection = dm.connect
    Parameters = <>
    SQL.Strings = (
      'select bolumkodu,count(*) as sayi from fatura'
      
        'where faturatipi=8 and tarih>='#39'18.08.2006'#39' and durum<>'#39'3'#39' and bo' +
        'lumkodu<>'#39#39
      'group by bolumkodu'
      'order by bolumkodu')
    Left = 16
  end
  object OkutulmayanQ: TADOQuery
    Connection = dm.connect
    Parameters = <>
    SQL.Strings = (
      'select bolumkodu,count(*) as sayi from fatura'
      
        'where faturatipi=8 and tarih>='#39'18.08.2006'#39' and durum<>'#39'3'#39' and bo' +
        'lumkodu<>'#39#39
      'group by bolumkodu'
      'order by bolumkodu')
    Left = 48
  end
  object FaturaQ: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    LockType = ltBatchOptimistic
    Parameters = <
      item
        Name = 'bolumkodu'
        DataType = ftString
        Size = 1
        Value = 'U'
      end
      item
        Name = 'tarih'
        DataType = ftDateTime
        Size = -1
        Value = 39009d
      end>
    SQL.Strings = (
      
        'select firmaadi=dbo.getfirmaadi(carikod),ambaradi=(select depoad' +
        'i from depolar with(nolock) where depolar.id=Fatura.ambar),subei' +
        'dx=isnull((select subeid from depolar with(nolock) where depolar' +
        '.id=Fatura.ambar),1),* from Fatura with(nolock) '
      
        'where faturatipi=8 and durum<>3 and bolumkodu=:bolumkodu and tar' +
        'ih>=:tarih')
    Left = 416
    Top = 7
  end
  object FaturaQS: TDataSource
    DataSet = FaturaQ
    Left = 384
    Top = 8
  end
end
